use MicroStrategy_Views
go
select ShiptoNumber from dbo.Sales_Star_Customer
where ShiptoNumber = SoldtoNumber

select * from dbo.Sales_Star_Customer
where SoldtoNumber = 7663611

select * from dbo.Sales_Star_Customer
where InvoicetoNumber= 7663611


use MicroStrategy_Views
go
select ShiptoNumber from dbo.Sales_Star_Customer
where ShiptoNumber = 7663611


use RD4_DWCR
go
select * FROM JDEGSSupplementalData
where 
SupplementalDataNumericKey1=7663611

select * FROM JDEABAddressBookMaster
where AddressNumber=7663611


use RD_Common
go

select ShiptoNumber, SoldtoNumber FROM 
RD_Common.dbo.Sales_Star_Customer A 
where
ShiptoNumber=7663611

select * from [RD_COMMON].[dbo].[Star_AddressBook] 
where addressnumber=7663611


use RD_COMMONWORK
go
select COUNT(*) FROM Join_Customer_Suppl
where CUSTOMERNUMBER=7663611